<?php
/**
 * WebmasterCity V3
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 * @category	WebmasterCity V3
 * @package	 Authentication
 * @copyright   (c) Copyright 2009-2010 by wmcity.nl
 *
 * $Id: Doctrine.php 214 2009-06-18 21:24:03Z luckyluke56 $
 */

class UserTable extends Doctrine_Table implements WMC_Auth_Adapter_Doctrine_Table
{
	public function checkCredentials($identity, $credential)
	{
		$query = Doctrine_Query::create()
			-> select('u.*')
			-> from('User u')
			-> where('u.username = ?', $identity)
			-> andWhere('u.user_password = ?', hash('sha256', $credential));

		return $query -> execute();
	}

	public function getUser($id)
	{
		$query = Doctrine_Query::create()
			-> select('u.*, s.*, w.*')
			-> from('User u')
			-> leftJoin('u.Sessions s')
			-> leftJoin('u.Websites w')
			-> where('u.id = ?', $id)
			-> limit(1);

		return $query -> fetchOne();
	}
}
